<!--
To change this template, choose Tools | Templates
and open the template in the editor.
-->
<!DOCTYPE html>
<html>
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
        <title></title>

        <link rel="stylesheet" type="text/css" href="css/tabela.css" media="screen" />
        <link rel="stylesheet" type="text/css" href="css/estilo.css" media="screen" />
        <script src="jscript/jquery-1.7.1.min.js" type="text/javascript"></script>
        <script src="jscript/jquery.tablesorter.min.js"></script>
        <script src="jscript/jquery.tablesorter.pager.js"></script>
        <script src="jscript/RelAlunos.js" type="text/javascript"></script>        
    </head>
    <body>
        <?php require_once 'classes/class.ConexaoBD.php';
        
        $ClsBD = new ConexaoBD;
        
        $strSQL = "SELECT DISTINCT Curso FROM cadastro ORDER BY Curso";
        $Cursos = $ClsBD->ExecutarQry($strSQL, "S");       
        ?>        
        <div id="wrapper">
            <div id="topo"></div>
            <div id="conteudo">
                <form id="parametros" name="parametros" method="post" onsubmit="return false;">
                    <span id="lblTitConsulta" class="SpanTitulo" >Parâmetros do Relatório</span><br>
                    Curso: <select id="txtCurso" class="LinhaInput">
                        <option value="0">Selecione um curso</option>
                        <?php 
                        if(is_resource($Cursos))
                            while($Linha = mysql_fetch_assoc($Cursos)) { ?>
                            <option value="<?php echo $Linha['Curso']; ?>">
                                <?php echo $Linha['Curso']; ?>
                            </option>
                        <?php } ?>
                    </select><br>
                    Turma: <select id="txtTurma" class="LinhaInput">
                        <option value="0" disabled="disabled">Selecione um curso</option>
                    </select>
                    <span id="lblData" class="SpanLabel">Data Presença: </span><input type="text" id="txtDtPresent" value="<? echo date("d/m/Y"); ?>" size="10" OnKeyPress="formatar(this, '##/##/####')" />                    
                </form>
            </div>
            <div class="divbotao">
                <button id="consultar">Consultar</button>
            </div>
            <br>
            <div id="Titulo" class="waiting" ></div>
            <br>
            <table id="tbAlunos" class="tablesorter" style="visibility: hidden">
                <thead>
                    <tr>
                        <th>Total de Alunos</th>
                        <th>Carga Horária</th>
                    </tr>
                </thead>
                <tbody></tbody>
            </table>
            <br><br>
            <div id ="funcoes" class="divsolta">
                <button id="btnImprimirRelatorio" style="line-height: 26px;" >Imprimir Relatório</button>
                <button id="btnImprimiListaPresenca" style="line-height: 26px;" >Imprimir Listagem de Presença</button>
            </div>
            <div id="rodape"></div>
        </div>
    </body>
</html>
